// 对操作数据库不同表的sql语句进行封装

// student表
let student = {
    insert: "INSERT INTO student(sno,sname,ssex,sage,sdepartion,specialty,class,phone,mail) VALUES(?,?,?,?,?,?,?,?,?)",
    update: "UPDATE student SET sage=?,sdepartion=?, specialty=?,class=?,phone=? ,mail=? where sno=?", //为防止修改篡位，全部写上
    delete: "DELETE FROM student WHERE sno=?",
    queryById: "SELECT * FROM student WHERE sno=?",
    queryAll: "SELECT * FROM student"
}

module.exports = {
    student
}